class CreateReports < ActiveRecord::Migration
  def self.up
  	create_table :reports do|t|
		t.column :teacher_id,:string,  :limit => 15
		t.column :year,:integer
		t.column :season,:integer
		t.column :karma,:integer
		t.column :delete, :string, :limit => 3, :default => 'NO', :null => false	
		t.column :create_on, :datetime
		t.column :update_on, :datetime
	end
  
  end

  def self.down
	 drop_table reports 
 end
end 

